You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If you DELETE a lot of vectors in a vec0 index, the vector chunks will contain a lot unused space. Sometimes it can be re-claimed when INSERT'ing new vectors (see #184), but there's no way to re-claim the disk space entirely.
So we should add a new "insert command" like FTS5 that allows you do manually fixup chunks and reclaim space:
INSERT INTO vec_items(vec_items) VALUES ('optimize');
This is easier said than done. This requires:
Finding unused entries in older chunks
Moving newer chunks into available old positions
Deleting "empty" older chunks
Making sure parition keys/metadata values stay the same
oh boy
The text was updated successfully, but these errors were encountered:
If you DELETE a lot of vectors in a vec0 index, the vector chunks will contain a lot unused space. Sometimes it can be re-claimed when INSERT'ing new vectors (see #184), but there's no way to re-claim the disk space entirely.
So we should add a new "insert command" like FTS5 that allows you do manually fixup chunks and reclaim space:
This is easier said than done. This requires:
oh boy
The text was updated successfully, but these errors were encountered: